﻿using System;
using System.Data;
using System.Data.SqlClient;


namespace DataAccess
{
    /// <summary>
    /// BaseObject is Base Object For Data Access Layer  
    /// </summary>
    public class BaseObject
    {
        /// <summary>
        /// Proc of tbltblEmployee
        /// </summary>
        #region Proc of tblEmployee

        public string usp_SelectEmployeesByID = "usp_SelectEmployee";
        public string usp_SelectEmployeesAll = "usp_SelectEmployeesAll";
        public string usp_SelectEmployeesDynamic = "usp_SelectEmployeesDynamic";
        public string usp_SelectEmployeesPaged = "usp_SelectEmployeesPaged";
        public string usp_InsertEmployee = "usp_InsertEmployee";
        public string usp_UpdateEmployee = "usp_UpdateEmployee";
        public string usp_DeleteEmployee = "usp_DeleteEmployee";

        #endregion

        /// <summary>
        /// Proc of tblPassenger 
        /// </summary>
        #region Proc of tblPassenger

        public string usp_SelecttbPassengersByID = "usp_SelecttbPassengersByAndPassengerID";
        public string usp_SelecttbPassengersAll = "usp_SelecttbPassengersAll";
        public string usp_SelecttbPassengersDynamic = "usp_SelecttbPassengersDynamic";
        public string usp_SelecttbPassengersPaged = "usp_SelecttbPassengersPaged";
        public string usp_InserttbPassenger = "usp_InserttbPassenger";
        public string usp_UpdatetbPassenger = "usp_UpdatetbPassenger";
        public string usp_DeletetbPassenger = "usp_DeletetbPassenger";

        #endregion

        /// <summary>
        /// Proc of tbStation
        /// </summary>
        #region Proc of tbStation

        public string usp_SelecttbStationsByID = "usp_SelecttbStation";
        public string usp_SelecttbStationsAll = "usp_SelecttbStationsAll";
        public string usp_SelecttbStationsDynamic = "usp_SelecttbStationsDynamic";
        public string usp_SelecttbStationsPaged = "usp_SelecttbStationsPaged";
        public string usp_InserttbStation = "usp_InserttbStation";
        public string usp_UpdatetbStation = "usp_UpdatetbStation";
        public string usp_DeletetbStation = "usp_DeletetbStationsByAndStationID";

        #endregion

        /// <summary>
        /// Proc of Distance
        /// </summary>
        #region Proc of Distance

        public string usp_SelectDistancesByID = "usp_SelectDistance";
        public string usp_SelectDistancesAll = "usp_SelectDistancesAll";
        public string usp_SelectDistancesDynamic = "usp_SelectDistancesDynamic";
        public string usp_SelectDistancesPaged = "usp_SelectDistancesPaged";
        public string usp_InsertDistance = "usp_InsertDistance";
        public string usp_UpdateDistance = "usp_UpdateDistance";
        public string usp_DeleteDistance = "usp_DeleteDistance";

        #endregion

        /// <summary>
        /// Proc of tbRoute
        /// </summary>
        #region Proc of tbRoute

        public string usp_SelecttbRoutesByID = "usp_SelecttbRoute";
        public string usp_SelecttbRoutesAll = "usp_SelecttbRoutesAll";
        public string usp_SelecttbRoutesDynamic = "usp_SelecttbRoutesDynamic";
        public string usp_SelecttbRoutesPaged = "usp_SelecttbRoutesPaged";
        public string usp_InserttbRoute = "usp_InserttbRoute";
        public string usp_UpdatetbRoute = "usp_UpdatetbRoute";
        public string usp_DeletetbRoute = "usp_DeletetbRoute";
        
        #endregion

        /// <summary>
        /// Proc of tbRouteDetail
        /// </summary>
        #region Proc of tbRouteDetail

        public string usp_SelecttbRouteDetailsByID = "usp_SelecttbRouteDetail";
        public string usp_SelecttbRouteDetailsAll = "usp_SelecttbRouteDetailsAll";
        public string usp_SelecttbRouteDetailsDynamic = "usp_SelecttbRouteDetailsDynamic";
        public string usp_SelecttbRouteDetailsPaged = "usp_SelecttbRouteDetailsPaged";
        public string usp_InserttbRouteDetail = "usp_InserttbRouteDetail";
        public string usp_UpdatetbRouteDetail = "usp_UpdatetbRouteDetail";
        public string usp_DeletetbRouteDetail = "usp_DeletetbRouteDetail";

        #endregion

        /// <summary>
        /// Proc of tbTrain
        /// </summary>
        #region Proc of tbTrain

        public string usp_SelecttbTrainsByID = "usp_SelecttbTrain";
        public string usp_SelecttbTrainsAll = "usp_SelecttbTrainsAll";
        public string usp_SelecttbTrainsDynamic = "usp_SelecttbTrainsDynamic";
        public string usp_SelecttbTrainsPaged = "usp_SelecttbTrainsPaged";
        public string usp_InserttbTrain = "usp_InserttbTrain";
        public string usp_UpdatetbTrain = "usp_UpdatetbTrain";
        public string usp_DeletetbTrain = "usp_DeletetbTrain";
        
        #endregion

        /// <summary>
        /// Proc of tbCoaches
        /// </summary>
        #region Proc of tbCoaches

        public string usp_SelecttbCoachesByID = "usp_SelecttbCoach";
        public string usp_SelecttbCoachesAll = "usp_SelecttbCoachesAll";
        public string usp_SelecttbCoachesDynamic = "usp_SelecttbCoachesDynamic";
        public string usp_SelecttbCoachesPaged = "usp_SelecttbCoachesPaged";
        public string usp_InserttbCoach = "usp_InserttbCoach";
        public string usp_UpdatetbCoach = "usp_UpdatetbCoach";
        public string usp_DeletetbCoach = "usp_DeletetbCoach";
        
        #endregion

        /// <summary>
        /// Proc of tbCoachType
        /// </summary>
        #region Proc of tbCoachType

        public string usp_SelecttbCoachTypesByID = "usp_SelecttbCoachType";
        public string usp_SelecttbCoachTypesAll = "usp_SelecttbCoachTypesAll";
        public string usp_SelecttbCoachTypesDynamic = "usp_SelecttbCoachTypesDynamic";
        public string usp_SelecttbCoachTypesPaged = "usp_SelecttbCoachTypesPaged";
        public string usp_InserttbCoachType = "usp_InserttbCoachType";
        public string usp_UpdatetbCoachType = "usp_UpdatetbCoachType";
        public string usp_DeletetbCoachType = "usp_DeletetbCoachType";

        #endregion

        /// <summary>
        /// Proc of Seates
        /// </summary>
        #region Proc of Seates

        public string usp_SelectSeatesByID = "usp_SelectSeate";
        public string usp_SelectSeatesAll = "usp_SelectSeatesAll";
        public string usp_SelectSeatesDynamic = "usp_SelectSeatesDynamic";
        public string usp_SelectSeatesPaged = "usp_SelectSeatesPaged";
        public string usp_InsertSeate = "usp_InsertSeate";
        public string usp_UpdateSeate = "usp_UpdateSeate";
        public string usp_DeleteSeate = "usp_DeleteSeate";

        #endregion

        /// <summary>
        /// Proc of tbSchedule
        /// </summary>
        #region Proc of tbSchedule

        public string usp_SelecttbSchedulesByID = "usp_SelecttbSchedule";
        public string usp_SelecttbSchedulesAll = "usp_SelecttbSchedulesAll";
        public string usp_SelecttbSchedulesDynamic = "usp_SelecttbSchedulesDynamic";
        public string usp_SelecttbSchedulesPaged = "usp_SelecttbSchedulesPaged";
        public string usp_InserttbSchedule = "usp_InserttbSchedule";
        public string usp_UpdatetbSchedule = "usp_UpdatetbSchedule";
        public string usp_DeletetbSchedule = "usp_DeletetbSchedule";
        
        #endregion

        /// <summary>
        /// Proc of CoachOfSchedule
        /// </summary>
        #region Proc of CoachOfSchedule

        public string usp_SelectCoachOfSchedulesByID = "usp_SelectCoachOfSchedule";
        public string usp_SelectCoachOfSchedulesAll = "usp_SelectCoachOfSchedulesAll";
        public string usp_SelectCoachOfSchedulesDynamic = "usp_SelectCoachOfSchedulesDynamic";
        public string usp_SelectCoachOfSchedulesPaged = "usp_SelectCoachOfSchedulesPaged";
        public string usp_InsertCoachOfSchedule = "usp_InsertCoachOfSchedule";
        public string usp_UpdateCoachOfSchedule = "usp_UpdateCoachOfSchedule";
        public string usp_DeleteCoachOfSchedule = "usp_DeleteCoachOfSchedule";

        #endregion

        /// <summary>
        /// Proc of ScheduleDetail
        /// </summary>
        #region Proc of ScheduleDetail

        public string usp_SelectScheduleDetailsByID = "usp_SelectScheduleDetail";
        public string usp_SelectScheduleDetailsAll = "usp_SelectScheduleDetailsAll";
        public string usp_SelectScheduleDetailsDynamic = "usp_SelectScheduleDetailsDynamic";
        public string usp_SelectScheduleDetailsPaged = "usp_SelectScheduleDetailsPaged";
        public string usp_InsertScheduleDetail = "usp_InsertScheduleDetail";
        public string usp_UpdateScheduleDetail = "usp_UpdateScheduleDetail";
        public string usp_DeleteScheduleDetail = "usp_DeleteScheduleDetail";

        #endregion

        /// <summary>
        /// Proc of tbOrder
        /// </summary>
        #region Proc of tbOrder

        public string usp_SelecttbOrdersByID = "usp_SelecttbOrder";
        public string usp_SelecttbOrdersAll = "usp_SelecttbOrdersAll";
        public string usp_SelecttbOrdersDynamic = "usp_SelecttbOrdersDynamic";
        public string usp_SelecttbOrdersPaged = "usp_SelecttbOrdersPaged";
        public string usp_InserttbOrder = "usp_InserttbOrder";
        public string usp_UpdatetbOrder = "usp_UpdatetbOrder";
        public string usp_DeletetbOrder = "usp_DeletetbOrder";
        
        #endregion

        /// <summary>
        /// Proc of tbTicket
        /// </summary>
        #region Proc of tbTicket

        public string usp_SelecttbTicketsByID = "usp_SelecttbTicket";
        public string usp_SelecttbTicketsAll = "usp_SelecttbTicketsAll";
        public string usp_SelectTicketInfo = "usp_SelectTicketInfo";
        public string usp_SearchTicketInfo = "usp_SearchTicketInfo";
        public string usp_SearchTicketInfoByID = "usp_SearchTicketInfoByID";
        public string usp_PrintTicketInfo = "usp_PrintTicketInfo";
        public string usp_SearchTicketByStatus = "usp_SearchTicketByStatus";
        public string usp_SelecttbTicketsDynamic = "usp_SelecttbTicketsDynamic";
        public string usp_SelecttbTicketsPaged = "usp_SelecttbTicketsPaged";
        public string usp_InserttbTicket = "usp_InserttbTicket";
        public string usp_UpdatetbTicket = "usp_UpdatetbTicket";
        public string usp_UpdateTicketStatus = "usp_UpdateTicketStatus";
        public string usp_DeletetbTicket = "usp_DeletetbTicket";
        #endregion

        #region contructor
        public BaseObject()
        {
        }
        #endregion

        #region Persist Methods
        public System.Data.SqlClient.SqlConnection CreateConnection()
        {
            //return new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["strDbConnection"].ToString());
            return new SqlConnection("Data Source=HUNGDQ-PC;Initial Catalog=dbProjectSem3;uid=sa;pwd=123456");
        }
        #endregion
    }
}
